<%@ page import="java.sql.*" contentType="text/html;charset=windows-1252"%>
<%
 //making connection
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String url = "jdbc:odbc:iranhk";
   Connection con = DriverManager.getConnection(url, "iranhk", "iranhk");

 //get result of search 
 String st;
 PreparedStatement pst;
  st=
   "select tb_tools.id,tb_tools.name,tb_tools.subject,tb_tools.dat,tb_members.id authorid,tb_members.name author "+
      "from tb_tools,tb_members " +      
      "where "+
         "(tb_tools.fk_author_id=tb_members.id) "+
     "order by tb_tools.dat; ";
     pst=con.prepareStatement(st);
     ResultSet rst=pst.executeQuery();    
     session.setAttribute("resultSet",rst);
     //out.print(pst.toString());
    /* while (rst.next()){ 
      out.print(rst.getString("NAME"));
    }*/
%>

<jsp:include page="../displayer/tools.jsp" flush="true">
  <jsp:param name="" value=""/>
</jsp:include> 